package com.loveyukari.dao;

import com.loveyukari.model.TourUser;
import net.sf.json.JSONObject;

import java.util.List;
import java.util.Map;

public interface TourDao {

    void updateTourExclude(int id,int exclude);


    void insertTour(String douyuName,Integer authId,String phone,String qq,String token,String ip);

    List<TourUser> selectByCreateTime(String date);

    TourUser selectTourByPhone(String phone);
    TourUser selectTourByToken(String token);
    TourUser selectTourById(int id);

    List<TourUser> selectAll();

    JSONObject selectTourItemByTicketNo(String ticketNo);

    List<JSONObject> selectByCity(String city);

    void updateTicketNo(Integer tourId, String city,String ticketNo);

    Map<Integer,Integer> selectDraw(String city,Integer status);

    void updateLastLoginTime(Integer tourId, String city);

    Integer selectTourIdByAuthId(int authId);

    String selectTicketNo(Integer tourId, String city);

    Integer selectTourItemStatus(Integer tourId, String city);

    void insertTourItem(Integer tourId,String city);

    void updateTourItemStatus(Integer tourId,String city,Integer status);



    JSONObject selectTicketCode(String ticketCode);

    void updateTicketCode(String ticketCode);

    void insertTicketCode(String ticketCode,String city);



}
